<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
        "https://raw.githubusercontent.com/rbatis/rbatis/master/rbatis-codegen/mybatis-3-mapper.dtd">
<mapper>
    <select id="select_custom_html_sql">
        `select * from bank `
        <where>
            <if test="number != ''">
                number like CONCAT('%', #{number}, '%')
            </if>
        </where>
    </select>

    <select id="select_page_by_htmlsql">
        `select * from bank where `
        <if test="number != ''">
            number like CONCAT('%', #{number}, '%')
        </if>
    </select>
</mapper>